package com.asm.mapper;


import com.asm.pojo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.poi.ss.formula.functions.T;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface SnvCpgAllMapper {


    List<SnvCpgAll> selectAllSnvCpgAll(@Param("tissue") String tissue,@Param("sampleType") String sampleType,
                                       @Param("d3d")String d3d,
                                       @Param("atac")String atac,@Param("enhancer")String enhancer,
                                       @Param("se")String se,@Param("insulator")String insulator);
    List<SnvCpgAll> selectAllSnvCpgAllBySearch(@Param("tissue") String tissue,@Param("sampleType")String sampleType,@Param("chr")String chr,@Param("search")String search);
    List<SnvCpgAll> selectHomeSNVFromAllSnvCpgAllBySearch(String search);
    List<SnvCpgAll> selectHomeSNVFromAllSnvCpgAllByRsList(List<? extends Object> rsList);

    List<BrowseCount> getElementByTissue(String tissue);

    List<SnvCpgAll> selectAllSnvCpgByCpg(@Param("cpgId") String cpgId);

    List<SnvCpgAll> selectTFbindingByRsList(List<Analysis1Sig> rsList);
    List<SnvCpgAll> selectTFbindingByRsListBySearch(@Param("rsList")List<Analysis1Sig> rsList,@Param("search")String search);
    List<SnvCpgAll> selectAnalysis3AsmByRsList(@Param("rsList")String[] rsList,@Param("tissue")String tissue,@Param("healthStatus") String[] healthStatus);
    List<SnvCpgAll> selectAnalysis3GeneByRsList(String[] rsList);

    List<Analysis3Gene> getGenesBysnv(@Param("genes") List<String> genes);
    List<SnvCpgAll> getDetailByASMid(@Param("asmid") String asmid);
}
